package manager.order;

import common.db.*;
import common.main.*;

public class OrderInfoBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String code = (String)inputTable.get("code");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT ");
		queryBuffer.append("CODE, GOODS_CODE, SHOPPER_ID, "); 
		queryBuffer.append("PURCHARSE_VALUE, ORDER_STATE, PAYMENT_WAY, "); 
		queryBuffer.append("DELIVERY_METHOD, OR_DATE, GY_DATE, "); 
		queryBuffer.append("BA_DATE, EN_DATE, COMPLETION_YN, SAVING_POINT, "); 
		queryBuffer.append("REG_ID, TO_CHAR(REG_DATE, 'YYYY-MM-DD') REG_DATE, REG_IP, "); 
		queryBuffer.append("UPD_ID, UPD_DATE, UPD_IP, ");  
		queryBuffer.append("USE_YN, RECEIVER, RECEIVER_PHONE1, RECEIVER_PHONE2, RECEIVER_PHONE3, ");
		queryBuffer.append("EMERGENCY1, EMERGENCY2, EMERGENCY3, ZIPCODE1, ZIPCODE2, ADDR1, ADDR2, ");
		queryBuffer.append("REQUIRE, USE_POINT, BANK_CODE, PURCHARSE_WAY ");
		queryBuffer.append("FROM ORDERLIST WHERE CODE='" + code+"'");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}